Adding or editing a charge tier markup group definition

The charge tier markup group definition tab provides a centralized location to add, edit, and delete definitions Axiom uses to reverse engineer the original cost of an item based on the markup percentages or multiplier applied by your organization's purchasing department.

To add or edit a charge tier markup group definition:

  1. From the Enterprise Decision Support home page, in the Cost Accounting section, click Modify a cost model or Create a cost model.

  2. Under the Methods section, click Define markup group definitions.

  3. Click the Charge tier markup tab.

  4. If there is not an existing markup group definition table version assigned to this cost model, the table will be empty.

    1. Click the link in the "Create or select a version here" text within the table.

    2. In the Modify a cost model dialog, from the Cost method exclusion drop-down, do one of the following and click Save:

      • To create a new version of the cost method exclusions table, select Create new version.

      • To assign an existing version of the cost method exclusions table, select the version from the list.

  5. If there is an existing markup group definition table version assigned to this cost model and you would like to modify it:

    1. Click the link in the cost model's name in the table's header.

    2. In the Modify a cost model dialog, from the Cost method exclusion drop-down, do one of the following and click Save:

      • To create a new version of the cost method exclusions table, select Create new version.

      • To assign an existing version of the cost method exclusions table, select the version from the list.

    NOTE: Steps 4-5 are optional. As part of the initial set up of the cost model, the version has likely already been created or selected. This step simply provides you a quick and easy way to select another version to use or create a new one from scratch, if needed.

  6. To show or hide inactive definitions in the table, click the gear icon in the upper-right portion of the screen and check/uncheck the Show only active definitions check box. While unchecked, the table shows inactive definitions shaded in yellow. Only active definitions include a check mark in the Active column.

  7. To create or select an existing markup group definition table version to assign to this cost model, click the link in the cost model's name in the table's header. In the Modify a cost model dialog, from the Markup drop-down located at the bottom of the page, do one of the following, and click Save:

    • To create a new version of the allocation definition table, click Create new version.

    • To assign an existing version of the allocation definition table, select the version from the list.

      NOTE: This step is optional. As part of the initial set up of the cost model, the version has likely already been created or selected. This step simply provides you a quick and easy way to select another version to use or create a new one from scratch, if needed.

  8. Do one of the following:
    • To add a definition, above the table click + Add definition.

    • To edit an account, in the Actions column of the account to edit, click the notepad icon .

      TIP: To search for a specific definition, use the Search field.

  9. In the Add/Edit markup group definition dialog, complete the following:

    Field Description
    Title* Type a name or title for the definition.
    Description Type the details for the definition.
    Activate?

    Do one of the following:

    • To activate the definition for cost model processing, click the toggle to Yes.
    • To deactivate the definition so that it is not processed with the cost model, click the toggle to No.

    NOTE: When you create a new definition, the system activates it by default.
    Markup type

    Select one of the following:

    • Markup - Apply markup amounts based on percentage and/or a fixed amount.
    • Multiplier - Apply markup amounts using a multiplying factor.

    NOTE: You can only select this option when creating a new definition. When you edit a definition, this information is read-only.
    Department*

    Type the department number in which to apply the definition.

    NOTE: The system excludes any department already assigned to the current mark group definition version.
    Cost category*

    Select the cost category in which to apply the definition.

    Cost categories will not display under the following conditions:

    • If the cost category is not included within the version of the dimension tables for the cost model

    • If the cost category and department combination already exists in an existing definition
    Range minimum

    Displays the minimum amount the item must meet to qualify for the tier level.

    This amount is determined by the amount entered in the Range maximum column from the preceding tier row. For example, if you enter 299.99 in Tier 2, the range minimum would display 300 for Tier 3.
    Range maximum Type the maximum amount to define the tier price range.
    Markup factor

    Type the percentage or multiplier markup to apply to the items that fall within the tier price range.
    + Fixed Amount

    Type an amount to add in addition to the percentage or multiplier markup. This step is optional.
  10. Do any of the following, as needed:
    • To add more tiers, click + Add tier at the bottom of the table.

    • To delete a row, click the trash bin icon in the Action column. At the Confirm delete markup tier prompt, click OK.

  11. After making your changes, click Save.
  12. If you are creating a new model, the next step is to maintain RVUs. Click Next in the bottom right corner of the page.
  13. If you are modifying an existing cost model, you can continue making changes to other parts of the model or go directly to processing the cost model if this is your only change.

    14. IMPORTANT: When making any changes to an existing cost model, you must reprocess it in order for the results to reflect the changes.